﻿CREATE TABLE [trUser].[tblDriverRatings] (
    [IDDriverRating]      BIGINT   IDENTITY (1, 1) NOT NULL,
    [IDDriver]            BIGINT   NOT NULL,
    [IDRatedByUserDevice] BIGINT   NOT NULL,
    [Rating]              SMALLINT NOT NULL,
    [DateCreated]         DATETIME CONSTRAINT [DF_tblDriverRatings_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]         DATETIME NULL,
    [DateInactive]        DATETIME NULL,
    CONSTRAINT [PK_tblDriverRatings] PRIMARY KEY CLUSTERED ([IDDriverRating] ASC)
);

